SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 48272: An arithmetic exception in an explicit pass-through query to DB2 on a z/OS system might result in incorrect results

DetailsHotfixAboutRate It

Incorrect data might occur when you use explicit pass-through with SAS/ACCESS® Interface to DB2 in a z/OS operating environment. The incorrect data occurs when DB2 returns a warning due to an arithmetic exception; for example, a division by zero.

To determine what the DB2 warning was, do one of the following: Either take the query and run it outside of SAS using something like SPUFI (SQL processor using file input), or do a Call Attachment Facility (CAF) trace by allocating a DSNTRACE data set and look in the generated trace messages for an SQLCODE that is not equal to 0.

To work around this issue, fix the code that led to the arithmetic exception.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS8.2 TS2M09.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.